/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_pricing_section.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_PRICING_SECTION
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_pricing_section.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_PRICING_SECTION::CTable_PPM_PRICING_SECTION( )
 :NPCRecordSet( )
{
  setTableName( "PPM_PRICING_SECTION" );
  prepareTable();
  prepareQuery();
 
  ID.setField( "ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  EVENT_PRICING_STRATEGY_ID.setField( "EVENT_PRICING_STRATEGY_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( EVENT_PRICING_STRATEGY_ID );
  PRICING_SECTION_ID.setField( "PRICING_SECTION_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICING_SECTION_ID );
  SECTION_TYPE_ID.setField( "SECTION_TYPE_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( SECTION_TYPE_ID );
  SECTION_CALCTYPE.setField( "SECTION_CALCTYPE", DATA_CHAR, 3, 0 );
  makeTableItem( SECTION_CALCTYPE );
  PRICING_SECTION_NAME.setField( "PRICING_SECTION_NAME", DATA_CHAR, 50, 0 );
  makeTableItem( PRICING_SECTION_NAME );
  PARENT_SECTION_ID.setField( "PARENT_SECTION_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PARENT_SECTION_ID );
  PRICING_REF_OBJECT_ID.setField( "PRICING_REF_OBJECT_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICING_REF_OBJECT_ID );
  ZONE_ITEM_ID.setField( "ZONE_ITEM_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( ZONE_ITEM_ID );
  CYCLE_SECTION_BEGIN.setField( "CYCLE_SECTION_BEGIN", DATA_DOUBLE, 22, 0 );
  makeTableItem( CYCLE_SECTION_BEGIN );
  CYCLE_SECTION_DURATION.setField( "CYCLE_SECTION_DURATION", DATA_DOUBLE, 22, 0 );
  makeTableItem( CYCLE_SECTION_DURATION );
  START_REF_VALUE_ID.setField( "START_REF_VALUE_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( START_REF_VALUE_ID );
  END_REF_VALUE_ID.setField( "END_REF_VALUE_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( END_REF_VALUE_ID );
  JUDGE_RESULT.setField( "JUDGE_RESULT", DATA_CHAR, 1, 0 );
  makeTableItem( JUDGE_RESULT );
  CALC_PRIORITY.setField( "CALC_PRIORITY", DATA_DOUBLE, 22, 0 );
  makeTableItem( CALC_PRIORITY );
}


CTable_PPM_PRICING_SECTION::CTable_PPM_PRICING_SECTION( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_PRICING_SECTION" );
  prepareTable();
  prepareQuery();
 
  ID.setField( "ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  EVENT_PRICING_STRATEGY_ID.setField( "EVENT_PRICING_STRATEGY_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( EVENT_PRICING_STRATEGY_ID );
  PRICING_SECTION_ID.setField( "PRICING_SECTION_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICING_SECTION_ID );
  SECTION_TYPE_ID.setField( "SECTION_TYPE_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( SECTION_TYPE_ID );
  SECTION_CALCTYPE.setField( "SECTION_CALCTYPE", DATA_CHAR, 3, 0 );
  makeTableItem( SECTION_CALCTYPE );
  PRICING_SECTION_NAME.setField( "PRICING_SECTION_NAME", DATA_CHAR, 50, 0 );
  makeTableItem( PRICING_SECTION_NAME );
  PARENT_SECTION_ID.setField( "PARENT_SECTION_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PARENT_SECTION_ID );
  PRICING_REF_OBJECT_ID.setField( "PRICING_REF_OBJECT_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICING_REF_OBJECT_ID );
  ZONE_ITEM_ID.setField( "ZONE_ITEM_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( ZONE_ITEM_ID );
  CYCLE_SECTION_BEGIN.setField( "CYCLE_SECTION_BEGIN", DATA_DOUBLE, 22, 0 );
  makeTableItem( CYCLE_SECTION_BEGIN );
  CYCLE_SECTION_DURATION.setField( "CYCLE_SECTION_DURATION", DATA_DOUBLE, 22, 0 );
  makeTableItem( CYCLE_SECTION_DURATION );
  START_REF_VALUE_ID.setField( "START_REF_VALUE_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( START_REF_VALUE_ID );
  END_REF_VALUE_ID.setField( "END_REF_VALUE_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( END_REF_VALUE_ID );
  JUDGE_RESULT.setField( "JUDGE_RESULT", DATA_CHAR, 1, 0 );
  makeTableItem( JUDGE_RESULT );
  CALC_PRIORITY.setField( "CALC_PRIORITY", DATA_DOUBLE, 22, 0 );
  makeTableItem( CALC_PRIORITY );
}

CTable_PPM_PRICING_SECTION::~CTable_PPM_PRICING_SECTION( )
{
    close();
}

